翻訳と辞書
Words near each other
・ Dual Scan
・ Dual Screen
・ Dual sector education
・ Dual segmented Langmuir probe
・ Dual Shock Wave
・ Dual SIM
・ Dual slalom
・ Dual space
・ Dual specificity phosphatase 27 (putative)
・ Dual speed focuser
・ Dual Spires
・ Dual State Monument
・ Dual superconductor model
・ Dual Survival
・ Dual system of government
DUAL table
・ Dual therapy stent
・ Dual topology
・ Dual total correlation
・ Dual Transfer Mode
・ Dual trigger insurance
・ Dual unionism
・ Dual Unity
・ Dual Vee Model
・ Dual wavelet
・ Dual wield
・ Dual Work Exchanger Energy Recovery
・ Dual! Parallel Trouble Adventure
・ Dual-Axis Radiographic Hydrodynamic Test Facility
・ Dual-band blade antenna


Dictionary Lists
翻訳と辞書 辞書検索 [ 開発暫定版 ]
スポンサード リンク

DUAL table : ウィキペディア英語版
DUAL table
The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. In Oracle, the table has a single VARCHAR2(1) column called DUMMY that has a value of 'X'. It is suitable for use in selecting a pseudo column such as SYSDATE or USER.
==Example use==
Oracle's SQL syntax requires the FROM clause but some queries don't require any tables - DUAL can be readily used in these cases.

SELECT 1+1
FROM DUAL;
SELECT 1
FROM DUAL;
SELECT USER
FROM DUAL;
SELECT SYSDATE
FROM DUAL;
SELECT
*
FROM DUAL;


抄文引用元・出典: フリー百科事典『 ウィキペディア(Wikipedia)
ウィキペディアで「DUAL table」の詳細全文を読む



スポンサード リンク
翻訳と辞書 : 翻訳のためのインターネットリソース

Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.